Automatic Generation of Trigger Rules for Integrity Enforcement in Relational Databases with View Definition

نویسندگان

  • Laura Mota-Herranz
  • Matilde Celma
چکیده

In this paper, we propose a method for integrity enforcement in relational databases with view de nition using the production rule mechanism provided by active database systems. The method generates a set of trigger rules at compile-time. This set of rules can repair at run-time the inconsistency produced by some transactions by executing a simple update over the extensional database. We also propose a logic metaprogram which implements the method.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Extracting UML/OCL Integrity Constraints and Derived Types from Relational Databases

Relational databases usually enforce relevant organizational business rules. This aspect is ignored by current database reverse engineering approaches which only focus on the extraction of the structural part of the conceptual schema. Other database elements like triggers, views, column constraints, etc. are not considered by those methods. As a result, the generated conceptual schema is incomp...

متن کامل

Classification and Specification of Update Problems*

Deductive databases are based on deductive rules (views) which define the common knowledge shared by different users by allowing to deduce new facts (derived or view facts) from base facts explicitly stored in the database. Deductive databases use logic programming as a base language and generalize relational databases by overcoming the limitations of relational languages in the definition of c...

متن کامل

Towards Automatic Generation of Rules for Incremental Maintenance of XML Views of Relational Data

This paper proposes a two-step approach to define rules for maintaining materialized XML views specified over relational databases. The first step concentrates on identifying all paths of the base schema that are relevant to a path of the view, with respect to an update. Hence, the corresponding views paths can be affected by the update. The second step creates rules that maintain all view path...

متن کامل

Metadata Enrichment for Automatic Data Entry Based on Relational Data Models

The idea of automatic generation of data entry forms based on data relational models is a common and known idea that has been discussed day by day more than before according to the popularity of agile methods in software development accompanying development of programming tools. One of the requirements of the automation methods, whether in commercial products or the relevant research projects, ...

متن کامل

The Dynamics of Database Views

The dynamics of relational database can be specified by means of Reiter’s formalism based on the situation calculus. The specification of transaction based database updates is given in terms of Successor State Axioms (SSAs) for the base tables of the database. These axioms completely describe the contents of the tables at an arbitrary state of the database that is generated by the execution of ...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1998